How to move below cell row value to above cell in particular column excel

Help Studio
, , , ,
1

Hi Team,

In excel I want to move below cell value to above remaining unwanted cell value should remove, Please help me anyone for this.

BB column cell value to map AA and CC column

Input excel:
image

Expected output:
image

Regards,
Raja G

2 Likes
2

Hi @Raja.G

What i see is you are moving the crentrw column by one cell up. If that is the case just use a loop on datatable and first check if it is the first row then dont move else change the cell value of b coulumn using index then delete the rows that you dont want using delete row or filter with blank on all 3 columns

Cheers

3

Hi @Raja.G,

What about below

Input
image

Outptu
image

Workflow

image
image430Ă—665 18.5 KB

Xaml
Sequence5.xaml (10.9 KB)

1 Like
4

Hi @RajKumar_DC ,

Please share correct xmal file, That above xmal not relevant one , please check share

Regards,
Raja G

5

Hi @Raja.G,

Plz check now

Sequence5.xaml (10.9 KB)
Test.xlsx (12.5 KB)

Thanks,

6

Hi @RajKumar_DC ,

Again same wrong xmal only shared, please check and send back

image
image1133Ă—782 24 KB

Regards,
Raja G

7

I attached Sequence5 Xaml but you opened some Test Xaml :thinking:

image
image917Ă—308 16.6 KB

8

Hi @Raja.G,

again
Sequence5.7z (2.0 KB)

9

image
image1537Ă—942 88.4 KB

I am facing issue

10

@Raja.G Can you check .7z once plz ? I have attached above

11

@RajKumar_DC ,

I used 7z also same issue only coming

Regards,
Raja G

12

@RajKumar_DC

Assign AA = dt1.rows(ind(-1)… ?
Assign CC =dt1.rows(ind(-1)… ?

Regards,
Raja G

13

Hi @Raja.G,

AA = dt1.Rows(indC-1).Item(“AA”).ToString
BB = Row(“BB”).ToString
CC = dt1.Rows(indC-1).Item(“CC”).ToString

Thanks,

14

Hi @RajKumar_DC ,

I didnt get clear picture of entire code so please share xmal file, else send entire code picture

Regards,
Raja G

15

Hi @supermanPunch ,

Please help me for this

Regards,
Raja G

16

Hi @Raja.G

See the workflow which raja gave in picture… use a loop on the original datatable you read from the excel.

Thwn inside loop use if condition to check if a and c is column is empty and b column has data

Then inside if write 3 assigns as above stated.

Then write a add data row there with the assigned values to a new datatable

Cheers

1 Like
17

Not only empty “AA” empty column if suppose “AA” already filled that row also i want

18

Hi @Raja.G

Please follow the steps and see…add conditions to if as you need. As of now you need to add data as per middle row and move them to row above…so the new datatable you are creating will have exactly same…i would suggest you to try this first

Cheers

1 Like
19

@Anil_G ,

I tried i couldnt get solution please share xmal file

Regards,
Raja G
Test.xaml (27.7 KB)

20

I added xmal above please check