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, 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.