Hello All - This is my first post here. I am trying to convert the rows under one field to different field names and concatenate each field name that was derived from rows with other field names. I have attached a sample worksheet showing what I want my end product to look like.
Thank you for your response. I guess I was not very clear in describing what it is that I want to achieve. If we looked at row 1-4 on the excel sheet I attached, I want to be able to concatenate the field names (Avg, Product1, etc,.) to the values in the first row (manual PMPM, PCC PMPM, etc.) So my end result would have field names that look like this:
Avg Man PMPM **, Avg PCC PMPM **, Avg Right PMPM ** ,Avg Final PMPM ** ,Product 1 Man PMPM ** etc.
Again similar techniques will be used but the key is to pivot the data so your field headers and 'Avg Man etc. are side by side. You can then concatenate the field headers and avg etc. values together and then pivot the data to your ideal format.