Choosing a cell and replicating it down for a column

Hi there,

I have a spreadsheet where I have 2 types of actions needs to be completed:

1. Un-pivoting the spreadsheet
2. Replicating in a linear format

Attached is a source data file, and I need the output in a one dimensional data format to be push on boarded into Microsoft Access. Can you please support on how we can accomplish this. Please note that we want to transform the "Source Data" tab in the sample spreadsheet into the "Desire Output" tab format.

1. We want to unpivot the chart in cell H10-S26 in the "Source Data" tab into column "I" in the "Desire Output" tab
2. We want to bring the value in cell C1,C3,C5 and E5 in the "Source Data" tab into column "A" "B" "C" "D" in the "Desire Output" tab and replicate it down as long as there are values in the other columns.

Thank you in advance

You can use unpivot and Get Excel Cell Value Properties to achieve what you want

www.etl-tools.com/wiki/aetle/processing_...working_with_unpivot

That works perfectly, thank you!