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?

Unit Number	255358	255358	272833	255370		272840	782673	271775		769525
PEC1783	271004	271004	769524	255379		807187	271278	255355
	271235	271235	271236	768744			768745
	271260	271260	271268	807188
			271244
			271263

<colgroup><col><col><col span="2"><col><col span="7"></colgroup><tbody>
</tbody>

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.