Concatenate every columns

[dgudkov]

Hi Matthieu and welcome to the Community!

It seems like this topic can help you:

Which technique for grouping many columns of data together (i.e. 50+ columns)

I have some employee data in a csv file (approx 170,000 rows and 60 columns wide) and I need to “condense” the data to summarize the unique rows. Very simple example: Employee Department Status WageType John Department 1 Full time Salaried Joe Department 1 Part time Salaried Joanna Department 2 Full time Salaried Jeff Department 2 Full time Salaried Jessie Department 1 Part time Hourly Jenny Department 1 Part time Salaried Jamal Department 1 Par…

Let me know if it didn't. In this case an example data set would be helpful.