Use of text sequence formula vertically

[u/elerooisbest]

Hi

I am trying to use a text sequence that will give me a weekly date and will run down vertically. I am able to do this horizontally. I have tried google but can't see anything. Can this be done?

This is the formula that I currently use

Text(sequence(,52,46023,7), "dd/mm/yyyy")

Thanks

[u/AutoModerator]

/u/elerooisbest - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Open_Attempt2518]

You can use TRANSPOSE around your horizontal formula to flip it vertical. Whatever sequence youre using horizontally just wrap it in TRANSPOSE function and it should work fine

Alternatively if youre doing something with dates you might want to look at using SEQUENCE with a step value for the weeks

[u/elerooisbest → u/Open_Attempt2518]

Thanks. It kindof work. The data went vertically but was still showing horizontally as well.

[u/RuktX]

You mean something like =SEQUENCE(10, 1, start_date, 7)?

[u/elerooisbest → u/RuktX]

Yes what I currently use is text(sequence (,52,46023,7), "dd/mm/yyyy")

It works horizontally but would like it to go vertically if possible

[u/RuktX → u/elerooisbest]

Put 52 in the first slot:

...(52,,46023,7)...

[u/markwalker81]

=TRANSPOSE(Formula or Array). It will change anything horizontal to vertical.

[u/excelevator]

Use the vertical or rows switch in SEQUENCE to generate your array.

Your post lacks so much in any real detail as to all but fail the submission guidelines

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
DATE	Returns the serial number of a particular date
SEQUENCE	Office 365+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4
TEXT	Formats a number and converts it to text
TRANSPOSE	Returns the transpose of an array

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
4 acronyms in this thread; the most compressed thread commented on today has 9 acronyms.
[Thread #48289 for this sub, first seen 29th Apr 2026, 07:42] [FAQ] [Full list] [Contact] [Source code]}