Multiple rows to single row

[vvkvvk]

How can i transfer multiple rows to single row, based on the first column? I got about 20000 rows of these.

excel.png

[Paul]

I think this code should do the trick, assuming your data is laid out in the columns as shown (starting in H). You can adjust the code as needed, of course. If you have more than 256 columns of data, adjust the number in the 'lastcol =...' line to a larger number. That's just starting in column 256 and then looking to the left to grab the column number of the last used column in each specific row.

Please Login or Register  to view this content.