HI guys,
I have a file that has a tremendous amount of rows and I'd like to switch the raw data from row oriented to column oriented for ease of analysis.
In my example, my raw data has content fields for numerous products. For example, for one product, I will be tracking the Product Title, # of Bullets, # of Images, e.t.c. There are a total of 15 content fields, represented by 15 rows for a specific product, but sometimes some products will report fewer. I mention this, because I can't use Excel's transpose function as the content fields are not consistent.
Can you advise if switching my row oriented data to column oriented is possible within Excel? You can technically achieve this view with a pivot table on the original raw data, but because pivot tables use numeric values to populate the cells, I can't use it for text.
I've attached an image to give an example - I'm looking forward to any insight/help members can provide!
I have a file that has a tremendous amount of rows and I'd like to switch the raw data from row oriented to column oriented for ease of analysis.
In my example, my raw data has content fields for numerous products. For example, for one product, I will be tracking the Product Title, # of Bullets, # of Images, e.t.c. There are a total of 15 content fields, represented by 15 rows for a specific product, but sometimes some products will report fewer. I mention this, because I can't use Excel's transpose function as the content fields are not consistent.
Can you advise if switching my row oriented data to column oriented is possible within Excel? You can technically achieve this view with a pivot table on the original raw data, but because pivot tables use numeric values to populate the cells, I can't use it for text.
I've attached an image to give an example - I'm looking forward to any insight/help members can provide!