Hi Guys,

I have data in a column (i.e. A1,A2,A3…….Ax) in sheet 1. This data needs to be displayed in sheet two in a row (i.e. C2,D2,D3…….Dx) in sheet2. Also I need the data to be dynamically updated if there are any changes in sheet 1.

Any suggestions other than using pivot tables?

Many Thanks

Robin