A
AHJuncti
I was curious if anyone knew of a way to convert a column into a row
Essentially we receive a spreadsheet a few times a month that has a fe
columns of information. Our database however can only accept cs
uploads and they have to follow a very strict template. In order t
properly upload the data that we are receiving I would need to turn
columns into rows (or optimally into a single cell with each piece o
data from that column separated by a comma).
Our template works as follows. We have rows for contact name, address
phone number, ect... At the end of the spreadsheet there are 3 column
in which this data needs to be placed. I'll call them Column X, Colum
Y, and Column Z. Inside these 3 columns is where the combined dat
needs to be placed.
Ex: Customer ABC Company sends us a spreadsheet of 100 items. I woul
fill in ABC's information in the appropriate fields, then in X,Y, and
I would need to place the 100 items from their spreadsheet. Those 10
Items are in Column A, B and C of their spreadsheet and would need t
be transferred to a single cell under column X,Y and Z respectively
separated by commas. (Ex. Column X would b
"datarow1,datarow2,datarow3,ect... till ,datarow100" of column A'
info, column Y would be the same for column B's info, and same for th
last columns.)
If it’s not possible to make an entire column become a csv inside of
single cell I figure if I can at least convert the column into a row
could then turn the sheet into a csv, open it in a text editor and cop
the whole line into a single excel cell. It would add an extra step
but still be a lot faster than our current type it all by hand method
Any ideas on this are appreciated, and I can supply a demo spreadshee
of what I’m attempting to do if needed. It’s hard to explain without
physical example
Essentially we receive a spreadsheet a few times a month that has a fe
columns of information. Our database however can only accept cs
uploads and they have to follow a very strict template. In order t
properly upload the data that we are receiving I would need to turn
columns into rows (or optimally into a single cell with each piece o
data from that column separated by a comma).
Our template works as follows. We have rows for contact name, address
phone number, ect... At the end of the spreadsheet there are 3 column
in which this data needs to be placed. I'll call them Column X, Colum
Y, and Column Z. Inside these 3 columns is where the combined dat
needs to be placed.
Ex: Customer ABC Company sends us a spreadsheet of 100 items. I woul
fill in ABC's information in the appropriate fields, then in X,Y, and
I would need to place the 100 items from their spreadsheet. Those 10
Items are in Column A, B and C of their spreadsheet and would need t
be transferred to a single cell under column X,Y and Z respectively
separated by commas. (Ex. Column X would b
"datarow1,datarow2,datarow3,ect... till ,datarow100" of column A'
info, column Y would be the same for column B's info, and same for th
last columns.)
If it’s not possible to make an entire column become a csv inside of
single cell I figure if I can at least convert the column into a row
could then turn the sheet into a csv, open it in a text editor and cop
the whole line into a single excel cell. It would add an extra step
but still be a lot faster than our current type it all by hand method
Any ideas on this are appreciated, and I can supply a demo spreadshee
of what I’m attempting to do if needed. It’s hard to explain without
physical example