I have 3 cells of information with the following text



Name of Person
log in
Password

skipped line then

Name of Person
log in
Password

and so on, I need to alphabetize the NAME OF PERSON cell so that the log in and password cells also appear underneath the alphabetized name of person cell follow?XcelScreenShot.png

cannot manipulate data in a picture. Please attach same as a file.

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2510

And why do you need Excel to present the data in a way your pra-pra-pra did put something similar on sheet of paper couple hundred years back? You did find a setup where you can't use any of Excel features!

Another question: what do you mean with 'alpahabetize'? Do you want to order your data alphabetically by name of person?

Consider the setup, where you have a table structured with columns (Column headers at top of column) like
PersonName LogIn Password
Best Buy shdhdh fgfgfg Qwerty23
Google Qwerty23
CityCard randolphbn@gmaoil.com Lwerty23

Then you can:
At any moment you need it, to use Order feature to order your table by any column or by combination of columns;
Set the filter on your table by value in certain column, or by values in several columns;
Get the info for certain person into another sheet (using e.g. VLOOKUP function);
etc.

Catchy answer and I get it. It's just that I have a lot of sheets that need the persons name and the next two lines in order. I do not use Excel daily where I should know how to use the formulas by any means. I'll figure it out and thanks for the reply.

R

An example added.

I used Named Table there.

On sheet Report, user can select any person registered on Data sheet, and it's LogIn and password are displayed automatically.

Btw. Having multiple sheets with same kind of information is a bad idea - when the info from those must be read to another sheet, you have to redesign your workbook every time a new name is added. E.g let's assume you have another sheet with table, where services those persons are offering are registered - like
tPersonServices: PersonName, ServiceID
And another table on another sheet - like
tServices: ServiceID, Service

Now on Report sheet, whenever you select a person, you can automatically get a list of all services this person is offering (using formulas which read info from those tables - you have to prepare a table for it with enough rows to get services for any person).

Attached Files

LoginInfo.xlsx (12.0 KB, 1 views)

AH I think I see but I realize that I uploaded a screenshot before, in the attached is an actual Xcel sheet with 5 separate entries. All I need is to have the first line in RED of each be in alphabetical order obviously along with the second and third lines info underneath each. See attached

The sample you attached does not look like the image you posted ( nothing in RED?)? There is data in two columns, also. Is it the A or D column? Power Query should solve this I think, once we know what you need exactly

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here you go.

Attached Files

TestAlphSample.xlsx (9.8 KB, 0 views)