Hello!
I am using the desktop version of Excel as part of the 365 bundle, all up to date on Windows 10.
My goal is to create a template I can use for adding closed captions to a video, and in this case, I want my final output to be an .srt file, so the format has to be specific. Like this:
My template has rows that have been set for 5-second intervals between captions (Again, a template to get started), and everything is combined into three cells. Then I transpose those cells to give me the format you see above.
So the part of the sheet I am transposing looks like this:
and I am using =TRANSPOSE(H3:J3) to give me the format that I need.
My hope was that I could grab the new transpose cells, and drag them down to auto-fill, but of course, it skips to every 4th row.
Looking for any direction someone might have to make sure it grabs each row.
I am using the desktop version of Excel as part of the 365 bundle, all up to date on Windows 10.
My goal is to create a template I can use for adding closed captions to a video, and in this case, I want my final output to be an .srt file, so the format has to be specific. Like this:
1 |
00:00:00,000 --> 00:00:05,000 |
Hola, soy Tania. Bienvenida a la Clínica de Planificación |
2 |
00:00:05,000 --> 00:00:10,000 |
Familiar de la calle Las Flores Sur. Me alegro de |
My template has rows that have been set for 5-second intervals between captions (Again, a template to get started), and everything is combined into three cells. Then I transpose those cells to give me the format you see above.
So the part of the sheet I am transposing looks like this:
1 | 00:00:00,000 --> 00:00:05,000 | Hola, soy Tania. Bienvenida a la Clínica de Planificación |
2 | 00:00:05,000 --> 00:00:10,000 | Familiar de la calle Las Flores Sur. Me alegro de |
3 | 00:00:10,000 --> 00:00:15,000 | que esté aquí para observar la intervención “De mujer |
4 | 00:00:15,000 --> 00:00:20,000 | a mujer: toma el control de tu salud” en acción. Este |
and I am using =TRANSPOSE(H3:J3) to give me the format that I need.
My hope was that I could grab the new transpose cells, and drag them down to auto-fill, but of course, it skips to every 4th row.
1 |
00:00:00,000 --> 00:00:05,000 |
Hola, soy Tania. Bienvenida a la Clínica de Planificación |
5 |
00:00:20,000 --> 00:00:25,000 |
curso será útil para las proveedoras que trabajan |
9 |
00:00:40,000 --> 00:00:45,000 |
de tu salud” o “De Mujer a Mujer”, como la llamaremos |
Looking for any direction someone might have to make sure it grabs each row.