Excel restricting columns to fixed number

Help Studio
, ,
1

Hi team,

We have an excel where we need to restrict the excel to a fixed column ,in my example to 4.
can someone assist.

Input:

ColumnA ColumnB ColumnC ColumnD
abc ggg ggg ggg
bbb bbb bbb bbb
ccc ccc ccc ccc
ddd ddd ddd ddd eee eee eee eee fff fff fff fff
Output
ColumnA ColumnB ColumnC ColumnD
abc ggg ggg ggg
bbb bbb bbb bbb
ccc ccc ccc ccc
ddd ddd ddd ddd
eee eee eee eee
fff fff fff fff
2

read table
filter table activity

filtertable
filtertable1271×747 24.5 KB

keep column names only which you want

enter your four columns one by one in output column section

3

My scenario is

I have an excel where if you see the input in the 4th row I have all the data, but it should actually come to new row for every 4 columns.