How to use Case Statements (about 30) on Multiple Rows of Data?
I have a spreadsheet that automatically pulls data from an outside database. That information is contained in one column, but can have 30 different possibilities for my Case Statement. I can get only 1 cell to run through the Case Statements-How can i get the entire row to process through the Case Statement and return the values in the adjacent row?? And the amount of rows within the cell will vary from day to day...
I have tried a Loop-but sent my computer into a perpetual processing state!!!!
Please help!!!
Could you post a sample of
Could you post a sample of the data and the loop you made that did not work?
back to basics
hi,
this question doesn't read very well..
try rephrasing to something like this:
- I have data in cell A1 that looks like this:
a,b,c
and I want it to be split into 3 columns like this:
a b c
(or whatever you want)
tks
Nick
text to colums
at first select the the first colums and follow the below instruction..........
go to file>data>Text to colums>Delimited>next>select comma>next>finish....
adk