Forum Discussion
Converting the data from Rows to columns. Or perhaps a Pivot table
I have data in one column, which is repeated in several rows. Those rows have data that I need to restructure in columns. Maybe the sample below makes more sense what I need to do. I need this Ran...
Delete all blank rows. Delete all total rows. Delete all duplicate header rows.
You can build a pivot table from what is left.
- Detlef_Lewin
Thank you, Detlef. Much appreciated. Any suggestions on how to put the right values in the pivot table to get the desired result?- Thank you very much, Detlef.
