Tjyylli

Why is the principal energy of an electron lower for excited electrons in a higher energy state?

Telemetry for feature health

What happens if I try to grapple mirror image?

Grepping string, but include all non-blank lines following each grep match

Why does a 97 / 92 key piano exist by Bösendorfer?

If A is dense in Q, then it must be dense in R.

Is there a RAID 0 Equivalent for RAM?

If the only attacker is removed from combat, is a creature still counted as having attacked this turn?

Is there a reason to prefer HFS+ over APFS for disk images in High Sierra and/or Mojave?

Ways of geometrical multiplication

Mimic lecturing on blackboard, facing audience

Why is participating in the European Parliamentary elections used as a threat?

The Digit Triangles

How do I prevent inappropriate ads from appearing in my game?

Why does the Persian emissary display a string of crowned skulls?

Can you identify this lizard-like creature I observed in the UK?

In One Punch Man, is King actually weak?

How to make a list of partial sums using forEach

Typing CO_2 easily

Animation: customize bounce interpolation

Make a Bowl of Alphabet Soup

Can I cause damage to electrical appliances by unplugging them when they are turned on?

I'm just a whisper. Who am I?

Review your own paper in Mathematics

How to transpose long list of groups of rows into columns (with code/formula)

How can I split Excel data from 1 column into 8 columns while keeping the data in a specific order?Excel - Split long column into multiple columns by empty cellPrevent Excel from changing formula of last row of table when adding a new rowHow to I simplify code that combines information and adds up values for certain columns?Transposing data from multiple columns to rows with preceding dataHow to count a string in all columns for only rows that contain a certain value?How To Consolidate Multiple Rows Into a ColumnExcel Formula to get Last 5 Non-Zero Values and Names from two columns respectively that have referencesFormula to sum a range of rows and copy the sums vertically downwards in a column?Excel - Formula based transpose from comma separated values to individual rows

0

I have data that I want to transpose, which should be easy enough. However, There's multiple rows I need to transpose in groups. Each last row in each group has a certain TEXT in there, so I don't know if there is some way to create a range searching for text versus a range? (Would this work? =if(isnumber(search(“TEXT”,A1)). I tried creating a macro, but obviously I need the code to transpose the data down the spreadsheet and not the same data over and over. Anyways, if there's any Excel gurus out there that know formulas, any help would be great!! Thanks in advance!

Here is a visual of what I need (Since I cannot format it, it looks funny, and since I'm new I couldn't embed it, so I included a link of a visual of what the rows/column look like/should look like:

enter image description here

From this:

Column A
Row A1
Row A2
Row A3
Row A4
Row A5
Row A6
Row A7
Row A8
Row A9
Row A10
Row A11
Row A12
Row A13

To this:
Col A Col B Col C Col D Col E
Row A1 Row A2 Row A3 Row A4
Row A5 Row A6 Row A7 Row A8 Row A9
Row A10 Row A11 Row A12 Row A13

microsoft-excel worksheet-function

share

asked 3 mins ago

a1rapidfaba1rapidfab

1

New contributor

a1rapidfab is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have data that I want to transpose, which should be easy enough. However, There's multiple rows I need to transpose in groups. Each last row in each group has a certain TEXT in there, so I don't know if there is some way to create a range searching for text versus a range? (Would this work? =if(isnumber(search(“TEXT”,A1)). I tried creating a macro, but obviously I need the code to transpose the data down the spreadsheet and not the same data over and over. Anyways, if there's any Excel gurus out there that know formulas, any help would be great!! Thanks in advance!

Here is a visual of what I need (Since I cannot format it, it looks funny, and since I'm new I couldn't embed it, so I included a link of a visual of what the rows/column look like/should look like:

enter image description here

From this:

Column A
Row A1
Row A2
Row A3
Row A4
Row A5
Row A6
Row A7
Row A8
Row A9
Row A10
Row A11
Row A12
Row A13

To this:
Col A Col B Col C Col D Col E
Row A1 Row A2 Row A3 Row A4
Row A5 Row A6 Row A7 Row A8 Row A9
Row A10 Row A11 Row A12 Row A13

microsoft-excel worksheet-function

share

asked 3 mins ago

a1rapidfaba1rapidfab

1

New contributor

a1rapidfab is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have data that I want to transpose, which should be easy enough. However, There's multiple rows I need to transpose in groups. Each last row in each group has a certain TEXT in there, so I don't know if there is some way to create a range searching for text versus a range? (Would this work? =if(isnumber(search(“TEXT”,A1)). I tried creating a macro, but obviously I need the code to transpose the data down the spreadsheet and not the same data over and over. Anyways, if there's any Excel gurus out there that know formulas, any help would be great!! Thanks in advance!

Here is a visual of what I need (Since I cannot format it, it looks funny, and since I'm new I couldn't embed it, so I included a link of a visual of what the rows/column look like/should look like:

enter image description here

From this:

Column A
Row A1
Row A2
Row A3
Row A4
Row A5
Row A6
Row A7
Row A8
Row A9
Row A10
Row A11
Row A12
Row A13

To this:
Col A Col B Col C Col D Col E
Row A1 Row A2 Row A3 Row A4
Row A5 Row A6 Row A7 Row A8 Row A9
Row A10 Row A11 Row A12 Row A13

microsoft-excel worksheet-function

share

asked 3 mins ago

a1rapidfaba1rapidfab

1

New contributor

a1rapidfab is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 3 mins ago

a1rapidfaba1rapidfab

1

New contributor

a1rapidfab is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 3 mins ago

a1rapidfaba1rapidfab

1

New contributor

a1rapidfab is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 3 mins ago

a1rapidfaba1rapidfab

1

New contributor

a1rapidfab is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 3 mins ago

a1rapidfaba1rapidfab

1