multiple outputs combined into one column

[slamanager]

Hi All,

i have a block of data, defined by record id (col A varible amounts of lines per record) and data with multiple details in Col B, I then have 10 find/search formulas that look at the cell with multiple criterias and extracts certain data (text / dates / dates and times / values / financial values etc).

so i can get all the data i need but im stuck how i then can combine the data into a table which i can query because i have several items of data on a single row.

col A record ID
col B Multiple data
col C - L formulas looking into col B data, if data is not found a " " is presented in the cell.

what would be the best way to collect in order , these pieces of data and list them on a new tab.

in the format
Col A Col B
ID1 $55 (found in B2, formula in C2)
ID1 $22 (found in B2, formula in E2)
ID1 01/01/2011 (found in B5, formula in H5)
ID1 $100 (found in B6, formula in I6)
ID1 7 (found in B6, formula in I7)

etc etc

 

[GlennUK]

You say:

how i then can combine the data into a table which i can query

... but your data is in a table format! What query do you want to do?

 

[slamanager]

Its not really a query (or it might be) i just wanted a way to show in order all of the items i extracted from the data

The bit i didnt know how to do it what happens when i have multiple item on one row and how i get them in a column in order.