Forum

Notifications
Clear all

how to get data in one row at once for multiple entries

2 Posts
2 Users
0 Reactions
75 Views
(@kunjanjain)
Posts: 1
New Member
Topic starter
 

Hi,

Data contain in the excel i want in this format :

date(01-01-2018)      party name(ABC Pvt ltd)     amount of clearing and forwarding charges(100 rs.)   amount of as per details(10 rs.) 

all in one row.

 

How to do using formula for multiple entries in  one sheet.

 

Please help 

 
Posted : 23/12/2018 3:50 am
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

Hello,

I am not sure I have understood your question correct, but I can at least advice you to not use that kind of data layout when gathering data, instead you should use a tabular format layout. It will simplify a lot when working with the data.

https://www.myonlinetraininghub.com/excel-tabular-data-format

Can you give more details of what it is you want help with?

 
Posted : 23/12/2018 6:38 pm
Share: