Hello, the data is currently in multiple cells but i can easily convert to 2 cells id required..
would like 1 in the first cell and the data in the next, this would then be the same for each row?
is this info ok?
thanks
ap
Hello, there 500 rows and there are max 15 cols of data at the moment, but the spreadsheet could change next month and have more cols of data.
thankyou
ap
Hello, i am having problems understanding how to convert some data in excel.
my data currently looks like..
1,a,b,c,d
2,e,f
3,g,h,i,j,k,l
4,a,c,f,g,h
i would like to convert it so it looks like..
1,a
1,b
1,c
1,d
2,e
2,f
3,g
etc..
would anyone be kind enough to help me out?
thankyou
a parm
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.