Convert Column Values to Rows

[timioluwatimi]

I have a table that looks like the above.  How do I convert the columns after "Value4" into rows so it looks like the below.

My actual data is  9800 rows  * 1500 columns

[messi007]

@timioluwatimi,

Could you please share the data instead of the screen shot ?

It will help us to give you the solution 🙂

Best Regards,

[Kenda · Accepted solution]

Hi @timioluwatimi 

Attached is a sample workflow that should be able to help. 

First, transpose your data, grouping by state and county. This way, all of the values are in the same column. From here, filter out the null rows then use a multi-row formula tool to number the rows for each state/county combo 1-4. Finally you can use a cross tab tool to get the values back into different columns.