Need help combining two columns

BEDE

New Member
Joined
Mar 29, 2024
Messages
18
Office Version
  1. 365
Platform
  1. Windows
Hello, I need help combing these these every other row.

1st - in DK26
TRANSPOSE(TAKE(AB12#,12))-TAKE(DROP(AB12#,1),12)
2nd
SEQUENCE(,COLUMNS(DK26#))&" "&"/"&" "&SEQUENCE(ROWS(DK26#))

I'm hoping to have the header first row, data second...


Screenshot 2024-05-02 111109.png
 

Attachments

  • 1714662723010.png
    1714662723010.png
    74.7 KB · Views: 4

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Where are columns DK and AB? Can you provide a sample of expected result?
The xl2bb add in is a much more useful tool in getting the forum to help you. Images are not copyable, and the forum must replicate your entire scenario, and they can get it wrong which just adds to more frustration for everyone. If you cannot use the xl2bb tool, then please paste a headered table into the chat.
Thanks in advance.
 
Upvote 0
Maybe
Excel Formula:
=LET(a,TRANSPOSE(TAKE(AB12#,12))-TAKE(DROP(AB12#,1),12),VSTACK(SEQUENCE(,COLUMNS(a))&" "&"/"&" "&SEQUENCE(ROWS(a)),a))
 
Upvote 0
Maybe
Excel Formula:
=LET(a,TRANSPOSE(TAKE(AB12#,12))-TAKE(DROP(AB12#,1),12),VSTACK(SEQUENCE(,COLUMNS(a))&" "&"/"&" "&SEQUENCE(ROWS(a)),a))
Keep running into this type of problem. I tried using scan by col with tocol/torow and then wrapping but no luck.
1714667767937.png
 
Upvote 0
Keep running into this type of problem. I tried using scan by col with tocol/torow and then wrapping but no luck.
View attachment 110877
Actually if I torow both then I can get that by wrapcol however is there no easier way to do this with maybe scan/map/byrow?

byrow lambda -> rowa rowb or something.
1714668089122.png
 
Upvote 0
is there no easier way to do this
I have no idea as
a) You have posted a number of images that tell us absolutely nothing.
b) You have not said anything about my suggestion.
 
Upvote 0
I have no idea as
a) You have posted a number of images that tell us absolutely nothing.
b) You have not said anything about my suggestion.
I apologize for the confusion. The first image is the result of your Let function. In that post I said or tried to say: I ran into this issue before I created this post, I tried fixing it using scan by col in torow.

In the second image I said actually: I was able to achieve this below, if I use torow and then wrap it using wrapcol however I wondering if its possible to achieve this end in an easier manner using bycol/byrow or something like scan/map
1714670238515.png
 
Last edited:
Upvote 0
Without knowing what your data is, or what you want as an output, it's almost impossible to say.
 
Upvote 0
Without knowing what your data is, or what you want as an output, it's almost impossible to say.
I want this as my output. just in reverse but my question is there an easier way to get here?

1714671053535.png
 
Upvote 0
Maybe
Excel Formula:
=LET(a,TRANSPOSE(TAKE(AB12#,12))-TAKE(DROP(AB12#,1),12),SORTBY(VSTACK(SEQUENCE(,COLUMNS(a))&" "&"/"&" "&SEQUENCE(ROWS(a)),a),VSTACK(SEQUENCE(ROWS(a),,,2),SEQUENCE(ROWS(a),,2,2))))
But if this does not work, you are going to have to post some data using the XL2BB add-in as already requested.
 
Upvote 0

Forum statistics

Threads
1,216,731
Messages
6,132,389
Members
449,725
Latest member
Enero1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top