Compile one list from multiple columns

[beekeeper37]

Hello,

Is there a way to compile a single list in a single column from data that I get from another search?

[TABLE="width: 880"]
<colgroup><col><col><col span="2"><col><col span="7"></colgroup><tbody>[TR]
[TD]Unit Number[/TD]
[TD="align: right"]255358[/TD]
[TD="align: right"]255358[/TD]
[TD="align: right"]272833[/TD]
[TD="align: right"]255370[/TD]
[TD][/TD]
[TD="align: right"]272840[/TD]
[TD="align: right"]782673[/TD]
[TD="align: right"]271775[/TD]
[TD][/TD]
[TD="align: right"]769525[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PEC1783[/TD]
[TD="align: right"]271004[/TD]
[TD="align: right"]271004[/TD]
[TD="align: right"]769524[/TD]
[TD="align: right"]255379[/TD]
[TD][/TD]
[TD="align: right"]807187[/TD]
[TD="align: right"]271278[/TD]
[TD="align: right"]255355[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]271235[/TD]
[TD="align: right"]271235[/TD]
[TD="align: right"]271236[/TD]
[TD="align: right"]768744[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]768745[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]271260[/TD]
[TD="align: right"]271260[/TD]
[TD="align: right"]271268[/TD]
[TD="align: right"]807188[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]271244[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]271263[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am entering the "PEC1783" info and then the other columns are populating as a result of an iferror formula. I would like to compile this list of numbers on another tab in a single column. I this possible?

Thanks
WD

 

[WassimN]

Hello Beekeeper37

Try and see if Copy-Paste Special-Transpose will help. I see a short list, so doing this manually should not be a problem. If this is a sample of a much larger data set, then possibly write some formulas to copy the values form each cell in the worksheet into a single Column. For example:

In A1 you will have =A1
In A2 you will have =B1
In A3 you will have =C1

and so on.

Hope this helps.