How to copy a column in an excel

[makboga]

Hi,
I have an excel

I want to copy order column as this format

and paste it in a web page.
I don’t want to take as a list or array I want it as a column.
Thanks.

[Anil_G (Anil Gorthi)]

@makboga

Use read range and then delete the non required columns using remove column/filter datatable

Or use read column activity

Cheers

[Suraj_B_Shetty (Suraj)]

@makboga Use read range and Filter Data Table activity to keep the required column.

[willjoe2442]

**Procedure

1. Select the row or column that you want to move or copy.
2. On the Home tab, in the Clipboard group, click Copy. or press Ctrl+C.
3. Select the upper-left cell of the paste area or the cell where you want to paste the value, cell format, or formula.
4. On the Home tab, in the Clipboard group, click the arrow below Paste.

Regards,
Will