I currently have around 2500 rows of data which I want to transpose into columns. Quattro can do the transpose ok but it deletes a bit of the data. ie Ive got "0001.jpg", "0002.jpg", "0003.jpg", etc and when I transpose I get.... 0001.jpg", 0002.jpg", 0003.jpg", etc Can someone please suggest a way in which I can keep the preceding " ? In excel I use the command ="""&A1 to add the " but it doesnt work in quattro. Can someone please help? My website is 2500 images short!
:doh: Simple answer is to add a second quote at the beginning! ie ""0001.jpg" transposed is "0001.jpg" :doh:
