Eliminating Space and plotting with transpose

Hello Friends

From Column A:C the values are plotted by eliminating space and with transpose (Column A:C to Row 1:3) in light yellow cells.

Please find the attached 2010 version file <Eliminating Space and plotting with transpose.xlsx>.

thanks

thilag

Put this formula in cell A1:

=INDEX($E$1:$P$3,COLUMNS($A:A),ROWS($1:1))

Copy across into B1:C1. Format B1 as a date, then copy all three formulae down.

Hope this helps.

Pete

My requirement is exactly opposite. In Columns A, B & C (A1:C3694) i have datas and i need to plot as in light yellow cells as shown in the attached file.

thilag

Okay, see attached file.

Hope this helps.

Pete

Hello Pete

thanks for your solution, with the help of a helper column this solution is best.

thanks again

thilag