To auto-populate the rest of the data by looking at previous data cell (pivot to columnised data).
Pivot = summarised data created from a pivot
interim = copy the summarised data into columnised data for further analysis
Result= what i want is to fill in the blanks (auto populate as it is very tedious and time consuming to copy the data from the top) with the previous headers to get a columnised data for further analysis.
See attached for details..