How to arrange unmanageable excel data

Question

0.00/5 (No votes)

See more:

Dear Team,

I have excel sheet in un-maange way like below

s	n
1	Affiliation No.830443
1	Name: 515 army base wkshop high school
1	Head/Principal Name:T. ARASAN
1	Status of the School:Secondary School
1	Affiliated up to: 31/03/2021
1	Address: 515 army base wkshop high school, cambridge road cross, 
1	Phone No: ,08025307559
1	Email: 515abwhighschool@gmail.com
2	Affiliation No.1930134
2	Name: A J C ENGLISH SCHOOL
2	Head/Principal Name:ANANDHAVALLI K
2	Status of the School:Secondary School
2	Affiliated up to: 31/03/2022
2	Address: LAL BAHADUR SHASTRI ROAD KUMBAKONAM TAMIL NADU ,612001
2	Phone No: 0435 ,2420730
2	Email: anandhiphysics@gmail.com
3	Affiliation No.130340
3	Name: A K R G TECHNO SCHOOL
3	Head/Principal Name:GUTTA PADMAJA
3	Status of the School:Secondary School
3	Affiliated up to: 31/03/2022
3	Address: NALLAJERLA ,534112
3	Phone No: 818 ,277993
3	Email: akrgschool@gmail.com


I want to manage data base of serial number. means searial number 1 in one row and 2 in two row.

What I have tried:

I have data in excel, tried with pivot table but not success. please help.

thanks in advance.

Posted 1-Aug-19 22:00pm

Nand Kishor Upadhyay

Updated 1-Aug-19 22:40pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2019-08-01T22:19:00

Solution 1

You can use Excel's Transpose method. Copy all cells for a serial number and then select the destination cell. Right click there and select Paste Special and tick the Transpose checkbox. The cells will be reformatted into a single row.

Posted 1-Aug-19 22:19pm

Richard MacCutchan

Comments

Nand Kishor Upadhyay 2-Aug-19 4:27am

21K serial number I have sir.

actually I want different row after every serial number.

Richard MacCutchan 2-Aug-19 4:52am

Then please follow the above instructions. If it does not do what you want then give proper details, "I want different row after every serial number." tells us nothing.

OriginalGriff · Answer 2 · 2019-08-01T22:40:00

Solution 2

Quote:
21K serial number I have sir.

actually I want different row after every serial number.

Richard has suggested the best solution - all you need to do is write a macro or use a formula which uses Transpose: How to convert rows to columns in Excel and vice versa[^]

Posted 1-Aug-19 22:40pm

OriginalGriff