Dear Friends, It would be helpful if someone can help me with following issue. I have an excel sheet attached in the below link. I have two sheets one which i recieve as an input(org). This input sheet should be converted into another sheet(sheet 3) of different format with datas from the input sheet(org). https://www.dropbox.com/s/bjxminzf9gfzrck/Demo%20file.xlsx?dl=0 1) in the sheet3 , Under the column title G with row title AA I need the datas fom Org sheet under the G And sum of all the rows starting with AA from orgsheet 2) in the sheet3, Under the column title G with row title AB I need the datas fom Org sheet under the G And sum of all the rows starting with BB from org sheet Could someone help on this please. Thanks in advance, Ram

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Converting excel sheet from one format to required format

Thread starter kramasundar
Start date Oct 10, 2018
Tags

datas format org sheet title

kramasundar

New Member

Oct 10, 2018

Dear Friends,

It would be helpful if someone can help me with following issue.

I have an excel sheet attached in the below link. I have two sheets one which i recieve as an input(org). This input sheet should be converted into another sheet(sheet 3) of different format with datas from the input sheet(org).

https://www.dropbox.com/s/bjxminzf9gfzrck/Demo file.xlsx?dl=0

1) in the sheet3 , Under the column title G with row title AA I need the datas fom Org sheet under the G And sum of all the rows starting with AA from orgsheet
2) in the sheet3, Under the column title G with row title AB I need the datas fom Org sheet under the G And sum of all the rows starting with BB from org sheet

Could someone help on this please.

Thanks in advance,
Ram