pl refer attached file
here i get certain code , date , price in column a, b, c respectively which i have to arrange like code in column a, then unique data of prices in column b to end (as available data) then price to be plotted accorss the data
e.g.
code 01-01-2001---02-01-2001------03-01-2001
a 50 60 70
b 90 400 500
c 45 54 74
got it as this kind of data is helpful for my index/match function
can anyone kindly give me hint or VBA code to autoformat data
note condition will always be same